From b793345f4098fa012d559b8f2d01f06d5418126c Mon Sep 17 00:00:00 2001 From: Stevan Earl Date: Sun, 26 Jul 2026 14:29:52 -0700 Subject: [PATCH] fix: codify solution to Problem #60 --- conversion/clean.sql | 12 ++++++++++++ 1 file changed, 12 insertions(+) diff --git a/conversion/clean.sql b/conversion/clean.sql index 28d320b..b5b8cf4 100644 --- a/conversion/clean.sql +++ b/conversion/clean.sql @@ -151,6 +151,18 @@ UPDATE biography SET b_animid_num = NULL WHERE b_animid_num = 0; + +-- +-- BIOGRAPHY_UPDATE_LOG +-- + +-- Problem #60 BIOGRAPHY_UPDATE_LOG.MadeBy contains the invalid combination +-- person code SF/EVL. The source-data resolution is to use EVL. +UPDATE biography_update_log + SET made_by = 'EVL' + WHERE made_by = 'SF/EVL'; + + -- -- follow -- -- 2.34.1